﻿using System.Linq;
using System.Text;
using System.Diagnostics;
using System.Runtime.Serialization;
using System.Collections;
using System.Data;
using System.ComponentModel;
using System.Data.OracleClient;
using WPFExcelReport.Helpers;
namespace WPFExcelReport
{
    public partial class VGSCOLOR
    {
        VGSDAT VGSDAT;
        VGASTGA VGASTGA;
        
    }
    public partial class VGSCOLOR
    {
        public readonly static VGSCOLOR Instance = new VGSCOLOR();
        public string GSCART { get { if (dwMaster == null) return ""; return dwMaster["GSCART"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCART"] = value; OnPropertyChanged("GSCART", value); } } //lENGth 20
        public string GSCVAR { get { if (dwMaster == null) return ""; return dwMaster["GSCVAR"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCVAR"] = value; OnPropertyChanged("GSCVAR", value); } } //lENGth 3
        public string GSCFARBE { get { if (dwMaster == null) return ""; return dwMaster["GSCFARBE"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCFARBE"] = value; OnPropertyChanged("GSCFARBE", value); } } //lENGth 10
        public string GSCBEZ { get { if (dwMaster == null) return ""; return dwMaster["GSCBEZ"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCBEZ"] = value; OnPropertyChanged("GSCBEZ", value); } } //lENGth 20

        #region======ColumnSchema==========
        /*
                 public string GSCMANDANT { get { if (dwMaster == null) return ""; return dwMaster["GSCMANDANT"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCMANDANT"] = value; OnPropertyChanged("GSCMANDANT", value); } } //lENGth 2
                  public double GSCAENDZL { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSCAENDZL"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSCAENDZL"] = value; OnPropertyChanged("GSCAENDZL", value); } } //lENGth 0
                 public string GSCAENDBEN { get { if (dwMaster == null) return ""; return dwMaster["GSCAENDBEN"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCAENDBEN"] = value; OnPropertyChanged("GSCAENDBEN", value); } } //lENGth 8
                 public double GSCAENDDAT { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSCAENDDAT"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSCAENDDAT"] = value; OnPropertyChanged("GSCAENDDAT", value); } } //lENGth 0
                 public string GSCNEUBEN { get { if (dwMaster == null) return ""; return dwMaster["GSCNEUBEN"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCNEUBEN"] = value; OnPropertyChanged("GSCNEUBEN", value); } } //lENGth 8
                 public double GSCNEUDAT { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSCNEUDAT"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSCNEUDAT"] = value; OnPropertyChanged("GSCNEUDAT", value); } } //lENGth 0
                 public string GSCSTATUS { get { if (dwMaster == null) return ""; return dwMaster["GSCSTATUS"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCSTATUS"] = value; OnPropertyChanged("GSCSTATUS", value); } } //lENGth 1
                 public string GSCSFKZ { get { if (dwMaster == null) return ""; return dwMaster["GSCSFKZ"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCSFKZ"] = value; OnPropertyChanged("GSCSFKZ", value); } } //lENGth 1
                 public string GSCFKARTNR { get { if (dwMaster == null) return ""; return dwMaster["GSCFKARTNR"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCFKARTNR"] = value; OnPropertyChanged("GSCFKARTNR", value); } } //lENGth 10
                 public string GSCKTFARBE { get { if (dwMaster == null) return ""; return dwMaster["GSCKTFARBE"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCKTFARBE"] = value; OnPropertyChanged("GSCKTFARBE", value); } } //lENGth 10
                 public string GSCBOM { get { if (dwMaster == null) return ""; return dwMaster["GSCBOM"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCBOM"] = value; OnPropertyChanged("GSCBOM", value); } } //lENGth 1
                 public string GSCBOMCGRP { get { if (dwMaster == null) return ""; return dwMaster["GSCBOMCGRP"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCBOMCGRP"] = value; OnPropertyChanged("GSCBOMCGRP", value); } } //lENGth 1
                 public string GSCFDVF { get { if (dwMaster == null) return ""; return dwMaster["GSCFDVF"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCFDVF"] = value; OnPropertyChanged("GSCFDVF", value); } } //lENGth 3
                 public string GSCVORB { get { if (dwMaster == null) return ""; return dwMaster["GSCVORB"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCVORB"] = value; OnPropertyChanged("GSCVORB", value); } } //lENGth 3
                 public string GSCNACHB { get { if (dwMaster == null) return ""; return dwMaster["GSCNACHB"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCNACHB"] = value; OnPropertyChanged("GSCNACHB", value); } } //lENGth 3
                 public double GSCFA { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSCFA"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSCFA"] = value; OnPropertyChanged("GSCFA", value); } } //lENGth 0
                 public string GSCRUESTGRP { get { if (dwMaster == null) return ""; return dwMaster["GSCRUESTGRP"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCRUESTGRP"] = value; OnPropertyChanged("GSCRUESTGRP", value); } } //lENGth 3
                 public string GSCPRUEFGRP { get { if (dwMaster == null) return ""; return dwMaster["GSCPRUEFGRP"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCPRUEFGRP"] = value; OnPropertyChanged("GSCPRUEFGRP", value); } } //lENGth 1
                 public string GSCSTATVF { get { if (dwMaster == null) return ""; return dwMaster["GSCSTATVF"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCSTATVF"] = value; OnPropertyChanged("GSCSTATVF", value); } } //lENGth 3
                 public string GSCKZDUMCOL { get { if (dwMaster == null) return ""; return dwMaster["GSCKZDUMCOL"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCKZDUMCOL"] = value; OnPropertyChanged("GSCKZDUMCOL", value); } } //lENGth 1
                 public string GSCPSEUDOCOL { get { if (dwMaster == null) return ""; return dwMaster["GSCPSEUDOCOL"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCPSEUDOCOL"] = value; OnPropertyChanged("GSCPSEUDOCOL", value); } } //lENGth 10
                 public string GSCTEXTSCHL { get { if (dwMaster == null) return ""; return dwMaster["GSCTEXTSCHL"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCTEXTSCHL"] = value; OnPropertyChanged("GSCTEXTSCHL", value); } } //lENGth 10
                 public string GSCMUFRB { get { if (dwMaster == null) return ""; return dwMaster["GSCMUFRB"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCMUFRB"] = value; OnPropertyChanged("GSCMUFRB", value); } } //lENGth 10
                 public double GSCSCHLIAUF { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSCSCHLIAUF"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSCSCHLIAUF"] = value; OnPropertyChanged("GSCSCHLIAUF", value); } } //lENGth 0
                 public double GSCFIXTEMP { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSCFIXTEMP"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSCFIXTEMP"] = value; OnPropertyChanged("GSCFIXTEMP", value); } } //lENGth 0
                 public double GSCFIXTIME { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSCFIXTIME"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSCFIXTIME"] = value; OnPropertyChanged("GSCFIXTIME", value); } } //lENGth 0
                 public double GSCABRASION { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSCABRASION"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSCABRASION"] = value; OnPropertyChanged("GSCABRASION", value); } } //lENGth 0
                 public double GSCABRAMTR { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSCABRAMTR"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSCABRAMTR"] = value; OnPropertyChanged("GSCABRAMTR", value); } } //lENGth 0
                 public string GSCPROGRP { get { if (dwMaster == null) return ""; return dwMaster["GSCPROGRP"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCPROGRP"] = value; OnPropertyChanged("GSCPROGRP", value); } } //lENGth 3
                 public string GSCARTGRP { get { if (dwMaster == null) return ""; return dwMaster["GSCARTGRP"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCARTGRP"] = value; OnPropertyChanged("GSCARTGRP", value); } } //lENGth 3
                 public string GSCRECHNUM { get { if (dwMaster == null) return ""; return dwMaster["GSCRECHNUM"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCRECHNUM"] = value; OnPropertyChanged("GSCRECHNUM", value); } } //lENGth 4
                 public double GSCRECHNR { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSCRECHNR"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSCRECHNR"] = value; OnPropertyChanged("GSCRECHNR", value); } } //lENGth 0
                 public string GSCPRGRP { get { if (dwMaster == null) return ""; return dwMaster["GSCPRGRP"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCPRGRP"] = value; OnPropertyChanged("GSCPRGRP", value); } } //lENGth 1
                 public double GSCPREIS { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSCPREIS"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSCPREIS"] = value; OnPropertyChanged("GSCPREIS", value); } } //lENGth 0
                 public double GSCZUAK { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSCZUAK"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSCZUAK"] = value; OnPropertyChanged("GSCZUAK", value); } } //lENGth 0
                 public string GSCZUPROZ { get { if (dwMaster == null) return ""; return dwMaster["GSCZUPROZ"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCZUPROZ"] = value; OnPropertyChanged("GSCZUPROZ", value); } } //lENGth 1
                 public string GSCANFART { get { if (dwMaster == null) return ""; return dwMaster["GSCANFART"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCANFART"] = value; OnPropertyChanged("GSCANFART", value); } } //lENGth 4
                 public double GSCWERT { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSCWERT"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSCWERT"] = value; OnPropertyChanged("GSCWERT", value); } } //lENGth 0
                 public string GSCWERTPROZ { get { if (dwMaster == null) return ""; return dwMaster["GSCWERTPROZ"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCWERTPROZ"] = value; OnPropertyChanged("GSCWERTPROZ", value); } } //lENGth 1
                 public double GSCZUAB { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSCZUAB"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSCZUAB"] = value; OnPropertyChanged("GSCZUAB", value); } } //lENGth 0
                 public string GSCZUABPROZ { get { if (dwMaster == null) return ""; return dwMaster["GSCZUABPROZ"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCZUABPROZ"] = value; OnPropertyChanged("GSCZUABPROZ", value); } } //lENGth 1
                 public double GSCZTWAHL { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSCZTWAHL"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSCZTWAHL"] = value; OnPropertyChanged("GSCZTWAHL", value); } } //lENGth 0
                 public double GSCVERLUST { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSCVERLUST"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSCVERLUST"] = value; OnPropertyChanged("GSCVERLUST", value); } } //lENGth 0
                 public double GSCKALKMG { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSCKALKMG"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSCKALKMG"] = value; OnPropertyChanged("GSCKALKMG", value); } } //lENGth 0
                 public string GSCLOAN { get { if (dwMaster == null) return ""; return dwMaster["GSCLOAN"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCLOAN"] = value; OnPropertyChanged("GSCLOAN", value); } } //lENGth 2
                 public string GSCLBAN { get { if (dwMaster == null) return ""; return dwMaster["GSCLBAN"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCLBAN"] = value; OnPropertyChanged("GSCLBAN", value); } } //lENGth 2
                 public string GSCLPAN { get { if (dwMaster == null) return ""; return dwMaster["GSCLPAN"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCLPAN"] = value; OnPropertyChanged("GSCLPAN", value); } } //lENGth 8
                 public string GSCPKL { get { if (dwMaster == null) return ""; return dwMaster["GSCPKL"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCPKL"] = value; OnPropertyChanged("GSCPKL", value); } } //lENGth 2
                 public string GSCMU { get { if (dwMaster == null) return ""; return dwMaster["GSCMU"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCMU"] = value; OnPropertyChanged("GSCMU", value); } } //lENGth 1
                 public string GSCMURLOD { get { if (dwMaster == null) return ""; return dwMaster["GSCMURLOD"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCMURLOD"] = value; OnPropertyChanged("GSCMURLOD", value); } } //lENGth 2
                 public string GSCMUPROD { get { if (dwMaster == null) return ""; return dwMaster["GSCMUPROD"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCMUPROD"] = value; OnPropertyChanged("GSCMUPROD", value); } } //lENGth 2
                 public string GSCMUCTOD { get { if (dwMaster == null) return ""; return dwMaster["GSCMUCTOD"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCMUCTOD"] = value; OnPropertyChanged("GSCMUCTOD", value); } } //lENGth 1
                 public string GSCMUBIRL { get { if (dwMaster == null) return ""; return dwMaster["GSCMUBIRL"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCMUBIRL"] = value; OnPropertyChanged("GSCMUBIRL", value); } } //lENGth 8
                 public double GSCMUDTRL { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["GSCMUDTRL"].ToString()); } set { if (dwMaster == null) return; dwMaster["GSCMUDTRL"] = value; OnPropertyChanged("GSCMUDTRL", value); } } //lENGth 0
                 public string GSCCOLPT1 { get { if (dwMaster == null) return ""; return dwMaster["GSCCOLPT1"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCCOLPT1"] = value; OnPropertyChanged("GSCCOLPT1", value); } } //lENGth 1
                 public string GSCCOLPT2 { get { if (dwMaster == null) return ""; return dwMaster["GSCCOLPT2"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCCOLPT2"] = value; OnPropertyChanged("GSCCOLPT2", value); } } //lENGth 1
                 public string GSCCOLPT3 { get { if (dwMaster == null) return ""; return dwMaster["GSCCOLPT3"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCCOLPT3"] = value; OnPropertyChanged("GSCCOLPT3", value); } } //lENGth 1
                 public string GSCCOLPT4 { get { if (dwMaster == null) return ""; return dwMaster["GSCCOLPT4"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCCOLPT4"] = value; OnPropertyChanged("GSCCOLPT4", value); } } //lENGth 1
                 public string GSCFILLER { get { if (dwMaster == null) return ""; return dwMaster["GSCFILLER"].ToString(); } set { if (dwMaster == null) return; dwMaster["GSCFILLER"] = value; OnPropertyChanged("GSCFILLER", value); } } //lENGth 52
        */
        #endregion
    }
}
